﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;

namespace Pipes.OfficeXml
{
  public class TestBed
  {
    public static void ExcelTest()
    {
      var file = @"C:\Users\edomke\Desktop\Global IHS Production_Apr13.xlsx";
      // 18, 23 --> 1 to 5609
      var reader = new IO.FileStreamSource(file).Pipe(new ExcelTableReader().SetRange(18, 1, 23, 5623).SetSheet("Sheet1"));
      reader.FirstRowColumnNames = true;

      foreach (var row in reader)
      {
        foreach (var value in row)
        {
          Debug.Print("{0} = {1}", value.Name, value.Value);
        }
      }
    }
  }
}
